<?php
namespace app\index\controller;

use think\Db;

class Index extends \think\Controller
{
    public function index()
    {
        return '<style type="text/css">*{ padding: 0; margin: 0; } .think_default_text{ padding: 4px 48px;} a{color:#2E5CD5;cursor: pointer;text-decoration: none} a:hover{text-decoration:underline; } body{ background: #fff; font-family: "Century Gothic","Microsoft yahei"; color: #333;font-size:18px} h1{ font-size: 100px; font-weight: normal; margin-bottom: 12px; } p{ line-height: 1.6em; font-size: 42px }</style><div style="padding: 24px 48px;"> <h1>:)</h1><p> ThinkPHP V5<br/><span style="font-size:30px">十年磨一剑 - 为API开发设计的高性能框架</span></p><span style="font-size:22px;">[ V5.0 版本由 <a href="http://www.qiniu.com" target="qiniu">七牛云</a> 独家赞助发布 ]</span></div><script type="text/javascript" src="http://tajs.qq.com/stats?sId=9347272" charset="UTF-8"></script><script type="text/javascript" src="http://ad.topthink.com/Public/static/client.js"></script><thinkad id="ad_bd568ce7058a1091"></thinkad>';
    }

	public function insertOne()
	{
		for ($i = 3; $i < 10; $i++) {
			Db::execute('insert into test values(:id, :name)', ['id' => $i, 'name' => 'zhangsan' . $i]);
		}
		$result = Db::query('select * from test');
		$this->assign('result', $result);
		return $this->fetch();
	}

	public function deleteOne()
	{
		$result = Db::execute('delete from test where id=:id', ['id' => 2]);
		if ($result !== false) {
			$this->assign('result', Db::query('select * from test'));
			return $this->fetch();
		}
	}

	public function updateOne()
	{
		$result = Db::execute('update test set name=:name where id=:id', ['id' => 1, 'name' => 'zhangsan1']);
		if ($result !== false) {
			$this->assign('result', Db::query('select * from test'));
			return $this->fetch();
		}
	}

	public function selectOne()
	{
		$result = Db::query('select id,name from test where id=?',[3]);
		if ($result !== false) {
			$this->assign('result', $result);
			return $this->fetch();
		}
	}
}
